Service Manager powered by HEAT

About Importing Data from SCCM into ISM

Use this section in conjunction with the information in Importing Data.

For on-premise deployments, you must install ISM Discovery to use SCCM to import data. For Cloud customers SCCM used the Discovery asset processor when importing data.

•About SCCM

•How the SCCM Integration Works

•Data Imported by the ISM Database

•Setting Up the SCCM Integration

•Importing Data from SCCM

•Service Manager powered by HEAT

About SCCM

You can import data from your Microsoft System Center Configuration Manager (SCCM) database into a Ivanti Service Manager configuration management database. This is a one-way import of data. Once you have mapped the fields, you can import data on a scheduled basis.

The configuration management database is a database that stores configuration records of configuration items. In Ivanti Service Manager, all configuration item records are stored in the Ivanti Service Manager database. A configuration item can be anything such as an asset, service component, or other item that is controlled by configuration management. Inventory management manages the service assets and configuration items to support the other service management processes.

Although Ivanti has not officially certified SCCM 2012, we consider it to be compliant with Ivanti Service Manager, assuming that it is backward compatible from the vendor to the certified version.

How the SCCM Integration Works

When you create the connection between the SCCM and Ivanti Service Manager databases and map the fields, the Data Integration Wizard automatically imports the data from the SCCM database into the Ivanti Service Manager database. You can schedule this import operation to occur periodically.

Each time the data is imported, it is automatically mapped directly into Ivanti Service Manager. No other plug-ins or applications are required.

Data Imported by the ISM Database

By default, the Ivanti Service Manager database imports the following information from SCCM data objects. The system is flexible, however, and you can define other objects.

Source SCCM	Method	Target
DateTimeNow	-->	Audit TimeStamp
SCCM	-->	Identity Property.ScanMethod
Computer_System_DATA.AgentID	-->	Identity Property.AgentVersion
Computer_System_DATA.MachineID Computer_System_DATA.InstanceKey	AssetIdentifier	Identity Property.ClientID
Computer_System_DATA.Description0	-->	Identity Property.DeviceDescription
Computer_System_DATA.Domain0 Computer_System_DATA.Name0	Concat	Identity Property.FullyQualifiedDomainName
Computer_System_DATA.Domain0	-->	Identity Property.DomainName
Computer_System_DATA.Name0	-->	Identity Property.HostName
Network_DATA.IPAddress0 Network_DATA.IPEnabled00 1	Select	Identity Property.IPaddress
Network_Data.IPSubnet0 Network_Data.IPEnabled00 1	Select	Identity Property .SubnetMask
Network_Data.IPSubnet0 Network_Data.IPEnabled00 1	Select	Identity Property.MACaddress
PC_BIOS_DATA.SerialNumber00	-->	Identity Property.SerialNumber
Computer_System_DATA.UserName0	-->	Identity Property.UserName
System_Enclosure_DATA.ChassisTypes00	-->	ComputerSystem Property.ChassisType
Physical	-->	ComputerSystem Property.ExecutionEnvironment
Computer_System_DATA.Manufacturer00	-->	ComputerSystem Property.Manufacturer
Computer_System_DATA.Model0	-->	ComputerSystem Property.Model
Operating_System_DATA.Caption0	-->	ComputerSystem Property.OperatingSystem
Operating_System_DATA.Caption0	-->	ComputerSystem Property.OSEdition
Operating_System_DATA.Version0	-->	ComputerSystem Property.MajorVersion
Operating_System_DATA.Version0	-->	ComputerSystem Property.MinorVersion
Operating_System_DATA.BuildNumber0	-->	ComputerSystem Property.BuildNumber
Processor_DATA.Name0 Processor_DATA.Status0 OK	Select	ComputerSystem Property.CPUArchitecture
Computer_System_DATA.Roles0 LM_Server Server Server_NT Server SQLServer Server LM_Workstation Workstation Workstation	CIType	ComputerSystem Property.CIType
Computer_System_DATA.Roles0 Computer_System_DATA.Model0 .*Virtual.* LM_Server > Server Server_NT > Server SQLServer > Server LM_Workstation > Workstation	CIType2	ComputerSystem Property.CIType
Logical_Disk_DATA.Size0	Sum	ComputerSystem Property.TotalDiskSpace
Logical_Disk_DATA.FreeSpace0	Sum	ComputerSystem Property.FreeDiskSpace
Computer_System_DATA.NumberOfProcessors	-->	ComputerSystem Property.CPUCount
Operating_System_DATA.CSDVersion0	-->	ComputerSystem Property.ServicePack
Network_DATA.InstanceKey	-->	Category Component Property-Hardware.Network
Network_DATA.IPAddress0	-->	Category Component Property-Hardware.Network
Network_DATA.IPEnabled00	-->	Category Component Property-Hardware.Network
Network_DATA.MACAddress0	-->	Category Component Property-Hardware.Network
Network_DATA.IPSubnet0	-->	Category Component Property-Hardware.Network
Logical_Disk_DATA.InstanceKey	-->	Category Component Property-Hardware.Network
Logical_Disk_DATA.DeviceID0	-->	Category Component Property-Hardware.Network
Logical_Disk_DATA.Description0	-->	Category Component Property-Hardware.Network
Logical_Disk_DATA.FileSystem0	-->	Category Component Property-Hardware.Network
Logical_Disk_DATA.FreeSpace0	-->	Category Component Property-Hardware.Network
Logical_Disk_DATA.Size0	-->	Category Component Property-Hardware.Network
PC_BIOS_DATA.InstanceKey	-->	Category Component Property-Hardware.Network
PC_BIOS_DATA.ReleaseDate0	-->	Category Component Property-Hardware.Network
PC_BIOS_DATA.Manufacturer0	-->	Category Component Property-Hardware.Network
PC_BIOS_DATA.Version0	-->	Category Component Property-Hardware.Network
Processor_DATA.InstanceKey	-->	Category Component Property-Hardware.Network
Processor_DATA.Name0	-->	Category Component Property-Hardware.Network
Processor_DATA.NormSpeed00	-->	Category Component Property-Hardware.Network

Setting Up the SCCM Integration

Ivanti Service Manager currently supports SCCM Release 2007. The data flow from SCCM to Ivanti Service Manager is unidirectional.

The connection from the integration server can be either through your VPN or through the internet with or without SSL encryption for the SCCM database server connection.

Before attempting to make the connection, ensure the following:

•SCCM is running.

•Your firewall is open for the Microsoft SQL server connection, for either Internet or VPN.

The default port for the Microsoft SQL server connection is TCP/IP port 1433. However, you can set up any TCP/IP port.

To enable encrypted connections to the Microsoft SQL server, see http://msdn.microsoft.com/en-us/library/ms189067%28v=sql.105%29.aspx.

Importing Data from SCCM

•Getting Started

•Object Mapping

•Filter Manager

•Field Mapping

Getting Started

To import data from SCCM into Ivanti Service Manager, follow these steps:

1.Perform steps 1 to 5 in the section called Setting Up a Data Import Connection.

2.In step 5, select SCCM.

3.Enter information into the fields.

Field	Description
Server Name	The name of the server where the SCCM database is located.
SSL Encryption	Specifies if the server supports SSL encryption.
Database Name	Name of the SCCM database.

4.Proceed to Object Mapping.

Object Mapping

1.Enter information into the fields.

Field name	Description
Mapping	The default mapping. Select the default or select Add New from the drop-down list.
Name	The mapping name. Use the default name, modify the name, or enter a new name for the mapping. To modify the existing name or add a new name, click Save as New.
Max file size	Read only. Shows the maximum file size that you can import. The maximum file size is 50 MB.
Source File Name	Read only. Taken from the value in the File Name field.
Source Mapping Objects	The source mapping objects. Select all objects that should be included. Ensure that Computer_System_Data is selected.
Batch size	Specifies the number of records that should be retrieved each time the database is queried. The default is 200. Do not make this number too small as it could cause excessive database activity.
Max size	Specifies the total number of records to process for any given job.
Root Table	The table that contains records that uniquely identify the computer systems in your organization. Keep the default as Computer_System_DATA. This is the top-level object, which is equivalent to the configuration item business object in the Ivanti Service Manager database.
Unique Key	The field that contains the key that uniquely identifies a computer record. This is essentially the primary key, which can be used to retrieve additional information about a computer.
Change-Time column	The date and time when a record is updated. Select TimeKey.

2.Proceed to Filter Manager.

Filter Manager

1.To view the column values of a SCCM database schema, run a Microsoft SQL query.

For example, to get the values for the Roles0 column from the Computer_System_Data.Roles0 root table, enter the query: Select distinct Computer_System_DATA.Roles0, *from Computer_System_DATA.

The system displays the following results:

Sample Mapping Results

SCCM Filter Manager

2.Proceed to Field Mapping.

Field Mapping

For additional information about field mapping, see Service Manager powered by HEAT

After setting up the filters for the table rows, map the fields and transformation. The first five mapped fields are required. Do not delete these.

1.If appropriate, select a transformation function from the middle column or leave it as is.

2.Select the field names to map between SCCM and Ivanti Service Manager.

The left column shows the fields from the root table column Computer_System_DATA.Roles0, which was selected on the previous page. The right column shows the asset identity of the matching fields in Ivanti Service Manager.

3.Proceed to Setting the Data Import or Web Service Connection Schedule.